﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CDmDjkDjackSpecieInfo" targetNamespace="http://tempuri.org/CDmDjkDjackSpecieInfo.xsd" xmlns:mstns="http://tempuri.org/CDmDjkDjackSpecieInfo.xsd" xmlns="http://tempuri.org/CDmDjkDjackSpecieInfo.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="dijiekeConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="dijiekeConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.msBsc.Xsd.DataTds.Properties.Settings.GlobalReference.Default.dijiekeConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="RealDataBaseConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="RealDataBaseConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.msBsc.Xsd.DataTds.Properties.Settings.GlobalReference.Default.RealDataBaseConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DJK_DJACK_SPECIEINFOTableAdapter" GeneratorDataComponentClassName="DJK_DJACK_SPECIEINFOTableAdapter" Name="DJK_DJACK_SPECIEINFO" UserDataComponentName="DJK_DJACK_SPECIEINFOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dijiekeConnectionString (Settings)" DbObjectName="dijieke.dbo.DJK_DJACK_SPECIEINFO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DJK_DJACK_SPECIEINFO] WHERE (([DJACK_SPECIEINFO_ID] = @Original_DJACK_SPECIEINFO_ID) AND ((@IsNull_BECOME_DJACK_TIME = 1 AND [BECOME_DJACK_TIME] IS NULL) OR ([BECOME_DJACK_TIME] = @Original_BECOME_DJACK_TIME)) AND ((@IsNull_DJACK_IS_CERTIFICATION = 1 AND [DJACK_IS_CERTIFICATION] IS NULL) OR ([DJACK_IS_CERTIFICATION] = @Original_DJACK_IS_CERTIFICATION)) AND ((@IsNull_CERTIFICATION_TIME = 1 AND [CERTIFICATION_TIME] IS NULL) OR ([CERTIFICATION_TIME] = @Original_CERTIFICATION_TIME)) AND ((@IsNull_DJACK_SERVICE_VOICE = 1 AND [DJACK_SERVICE_VOICE] IS NULL) OR ([DJACK_SERVICE_VOICE] = @Original_DJACK_SERVICE_VOICE)) AND ((@IsNull_DJACK_INTRODUCE = 1 AND [DJACK_INTRODUCE] IS NULL) OR ([DJACK_INTRODUCE] = @Original_DJACK_INTRODUCE)) AND ((@IsNull_DJACK_CONACTION_TIME = 1 AND [DJACK_CONACTION_TIME] IS NULL) OR ([DJACK_CONACTION_TIME] = @Original_DJACK_CONACTION_TIME)) AND ((@IsNull_DJACK_TRANS_ACCOUNT = 1 AND [DJACK_TRANS_ACCOUNT] IS NULL) OR ([DJACK_TRANS_ACCOUNT] = @Original_DJACK_TRANS_ACCOUNT)) AND ((@IsNull_TRANS_ACCOUNT_TYPE = 1 AND [TRANS_ACCOUNT_TYPE] IS NULL) OR ([TRANS_ACCOUNT_TYPE] = @Original_TRANS_ACCOUNT_TYPE)) AND ((@IsNull_DJACK_SCAN_NUM = 1 AND [DJACK_SCAN_NUM] IS NULL) OR ([DJACK_SCAN_NUM] = @Original_DJACK_SCAN_NUM)) AND ((@IsNull_DJACK_SERVICE_TYPE = 1 AND [DJACK_SERVICE_TYPE] IS NULL) OR ([DJACK_SERVICE_TYPE] = @Original_DJACK_SERVICE_TYPE)) AND ((@IsNull_DJACK_ACCOUNT_BALANCE = 1 AND [DJACK_ACCOUNT_BALANCE] IS NULL) OR ([DJACK_ACCOUNT_BALANCE] = @Original_DJACK_ACCOUNT_BALANCE)) AND ((@IsNull_DJACK_TRANS_COUNT = 1 AND [DJACK_TRANS_COUNT] IS NULL) OR ([DJACK_TRANS_COUNT] = @Original_DJACK_TRANS_COUNT)) AND ((@IsNull_SPECIE_IS_DELETED = 1 AND [SPECIE_IS_DELETED] IS NULL) OR ([SPECIE_IS_DELETED] = @Original_SPECIE_IS_DELETED)) AND ((@IsNull_DJACK_SPECIE_RMK = 1 AND [DJACK_SPECIE_RMK] IS NULL) OR ([DJACK_SPECIE_RMK] = @Original_DJACK_SPECIE_RMK)) AND ((@IsNull_BANK_ID = 1 AND [BANK_ID] IS NULL) OR ([BANK_ID] = @Original_BANK_ID)) AND ((@IsNull_BANK_ACCOUNT = 1 AND [BANK_ACCOUNT] IS NULL) OR ([BANK_ACCOUNT] = @Original_BANK_ACCOUNT)) AND ((@IsNull_BANK_ACCOUNT_NME = 1 AND [BANK_ACCOUNT_NME] IS NULL) OR ([BANK_ACCOUNT_NME] = @Original_BANK_ACCOUNT_NME)) AND ((@IsNull_ADVICE_HTML_URL = 1 AND [ADVICE_HTML_URL] IS NULL) OR ([ADVICE_HTML_URL] = @Original_ADVICE_HTML_URL)) AND ((@IsNull_DJACK_TRADING_NUMBER = 1 AND [DJACK_TRADING_NUMBER] IS NULL) OR ([DJACK_TRADING_NUMBER] = @Original_DJACK_TRADING_NUMBER)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_SPECIEINFO_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_SPECIEINFO_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BECOME_DJACK_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BECOME_DJACK_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_BECOME_DJACK_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="BECOME_DJACK_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_IS_CERTIFICATION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_IS_CERTIFICATION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_DJACK_IS_CERTIFICATION" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DJACK_IS_CERTIFICATION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CERTIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CERTIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CERTIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CERTIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_SERVICE_VOICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_SERVICE_VOICE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_SERVICE_VOICE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_SERVICE_VOICE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_INTRODUCE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_INTRODUCE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_INTRODUCE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_INTRODUCE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_CONACTION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_CONACTION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_CONACTION_TIME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_CONACTION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_TRANS_ACCOUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_TRANS_ACCOUNT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_TRANS_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_TRANS_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRANS_ACCOUNT_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRANS_ACCOUNT_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TRANS_ACCOUNT_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRANS_ACCOUNT_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_SCAN_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_SCAN_NUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DJACK_SCAN_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_SCAN_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_SERVICE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_SERVICE_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DJACK_SERVICE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_SERVICE_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_ACCOUNT_BALANCE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_ACCOUNT_BALANCE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DJACK_ACCOUNT_BALANCE" Precision="15" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DJACK_ACCOUNT_BALANCE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_TRANS_COUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_TRANS_COUNT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DJACK_TRANS_COUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_TRANS_COUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SPECIE_IS_DELETED" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SPECIE_IS_DELETED" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_SPECIE_IS_DELETED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SPECIE_IS_DELETED" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_SPECIE_RMK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_SPECIE_RMK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_SPECIE_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_SPECIE_RMK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BANK_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BANK_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BANK_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BANK_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BANK_ACCOUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BANK_ACCOUNT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BANK_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BANK_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BANK_ACCOUNT_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BANK_ACCOUNT_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BANK_ACCOUNT_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BANK_ACCOUNT_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ADVICE_HTML_URL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ADVICE_HTML_URL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ADVICE_HTML_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADVICE_HTML_URL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_TRADING_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_TRADING_NUMBER" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DJACK_TRADING_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_TRADING_NUMBER" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DJK_DJACK_SPECIEINFO] ([DJACK_SPECIEINFO_ID], [BECOME_DJACK_TIME], [DJACK_IS_CERTIFICATION], [CERTIFICATION_TIME], [DJACK_SERVICE_VOICE], [DJACK_INTRODUCE], [DJACK_CONACTION_TIME], [DJACK_TRANS_ACCOUNT], [TRANS_ACCOUNT_TYPE], [DJACK_SCAN_NUM], [DJACK_SERVICE_TYPE], [DJACK_TRAVEL_ADVICE], [DJACK_ACCOUNT_BALANCE], [DJACK_TRANS_COUNT], [SPECIE_IS_DELETED], [DJACK_SPECIE_RMK], [BANK_ID], [BANK_ACCOUNT], [BANK_ACCOUNT_NME], [ADVICE_HTML_URL], [DJACK_TRADING_NUMBER]) VALUES (@DJACK_SPECIEINFO_ID, @BECOME_DJACK_TIME, @DJACK_IS_CERTIFICATION, @CERTIFICATION_TIME, @DJACK_SERVICE_VOICE, @DJACK_INTRODUCE, @DJACK_CONACTION_TIME, @DJACK_TRANS_ACCOUNT, @TRANS_ACCOUNT_TYPE, @DJACK_SCAN_NUM, @DJACK_SERVICE_TYPE, @DJACK_TRAVEL_ADVICE, @DJACK_ACCOUNT_BALANCE, @DJACK_TRANS_COUNT, @SPECIE_IS_DELETED, @DJACK_SPECIE_RMK, @BANK_ID, @BANK_ACCOUNT, @BANK_ACCOUNT_NME, @ADVICE_HTML_URL, @DJACK_TRADING_NUMBER);
SELECT DJACK_SPECIEINFO_ID, BECOME_DJACK_TIME, DJACK_IS_CERTIFICATION, CERTIFICATION_TIME, DJACK_SERVICE_VOICE, DJACK_INTRODUCE, DJACK_CONACTION_TIME, DJACK_TRANS_ACCOUNT, TRANS_ACCOUNT_TYPE, DJACK_SCAN_NUM, DJACK_SERVICE_TYPE, DJACK_TRAVEL_ADVICE, DJACK_ACCOUNT_BALANCE, DJACK_TRANS_COUNT, SPECIE_IS_DELETED, DJACK_SPECIE_RMK, BANK_ID, BANK_ACCOUNT, BANK_ACCOUNT_NME, ADVICE_HTML_URL, DJACK_TRADING_NUMBER FROM DJK_DJACK_SPECIEINFO WHERE (DJACK_SPECIEINFO_ID = @DJACK_SPECIEINFO_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_SPECIEINFO_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_SPECIEINFO_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@BECOME_DJACK_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="BECOME_DJACK_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@DJACK_IS_CERTIFICATION" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DJACK_IS_CERTIFICATION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CERTIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CERTIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_SERVICE_VOICE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_SERVICE_VOICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_INTRODUCE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_INTRODUCE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_CONACTION_TIME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_CONACTION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_TRANS_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_TRANS_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TRANS_ACCOUNT_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRANS_ACCOUNT_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DJACK_SCAN_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_SCAN_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DJACK_SERVICE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_SERVICE_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_TRAVEL_ADVICE" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="DJACK_TRAVEL_ADVICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DJACK_ACCOUNT_BALANCE" Precision="15" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DJACK_ACCOUNT_BALANCE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DJACK_TRANS_COUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_TRANS_COUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SPECIE_IS_DELETED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SPECIE_IS_DELETED" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_SPECIE_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_SPECIE_RMK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BANK_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BANK_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BANK_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BANK_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BANK_ACCOUNT_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BANK_ACCOUNT_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ADVICE_HTML_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADVICE_HTML_URL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DJACK_TRADING_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_TRADING_NUMBER" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT DJACK_SPECIEINFO_ID, BECOME_DJACK_TIME, DJACK_IS_CERTIFICATION, CERTIFICATION_TIME, DJACK_SERVICE_VOICE, DJACK_INTRODUCE, DJACK_CONACTION_TIME, DJACK_TRANS_ACCOUNT, TRANS_ACCOUNT_TYPE, DJACK_SCAN_NUM, DJACK_SERVICE_TYPE, DJACK_TRAVEL_ADVICE, DJACK_ACCOUNT_BALANCE, DJACK_TRANS_COUNT, SPECIE_IS_DELETED, DJACK_SPECIE_RMK, BANK_ID, BANK_ACCOUNT, BANK_ACCOUNT_NME, ADVICE_HTML_URL, DJACK_TRADING_NUMBER FROM dbo.DJK_DJACK_SPECIEINFO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DJK_DJACK_SPECIEINFO] SET [DJACK_SPECIEINFO_ID] = @DJACK_SPECIEINFO_ID, [BECOME_DJACK_TIME] = @BECOME_DJACK_TIME, [DJACK_IS_CERTIFICATION] = @DJACK_IS_CERTIFICATION, [CERTIFICATION_TIME] = @CERTIFICATION_TIME, [DJACK_SERVICE_VOICE] = @DJACK_SERVICE_VOICE, [DJACK_INTRODUCE] = @DJACK_INTRODUCE, [DJACK_CONACTION_TIME] = @DJACK_CONACTION_TIME, [DJACK_TRANS_ACCOUNT] = @DJACK_TRANS_ACCOUNT, [TRANS_ACCOUNT_TYPE] = @TRANS_ACCOUNT_TYPE, [DJACK_SCAN_NUM] = @DJACK_SCAN_NUM, [DJACK_SERVICE_TYPE] = @DJACK_SERVICE_TYPE, [DJACK_TRAVEL_ADVICE] = @DJACK_TRAVEL_ADVICE, [DJACK_ACCOUNT_BALANCE] = @DJACK_ACCOUNT_BALANCE, [DJACK_TRANS_COUNT] = @DJACK_TRANS_COUNT, [SPECIE_IS_DELETED] = @SPECIE_IS_DELETED, [DJACK_SPECIE_RMK] = @DJACK_SPECIE_RMK, [BANK_ID] = @BANK_ID, [BANK_ACCOUNT] = @BANK_ACCOUNT, [BANK_ACCOUNT_NME] = @BANK_ACCOUNT_NME, [ADVICE_HTML_URL] = @ADVICE_HTML_URL, [DJACK_TRADING_NUMBER] = @DJACK_TRADING_NUMBER WHERE (([DJACK_SPECIEINFO_ID] = @Original_DJACK_SPECIEINFO_ID) AND ((@IsNull_BECOME_DJACK_TIME = 1 AND [BECOME_DJACK_TIME] IS NULL) OR ([BECOME_DJACK_TIME] = @Original_BECOME_DJACK_TIME)) AND ((@IsNull_DJACK_IS_CERTIFICATION = 1 AND [DJACK_IS_CERTIFICATION] IS NULL) OR ([DJACK_IS_CERTIFICATION] = @Original_DJACK_IS_CERTIFICATION)) AND ((@IsNull_CERTIFICATION_TIME = 1 AND [CERTIFICATION_TIME] IS NULL) OR ([CERTIFICATION_TIME] = @Original_CERTIFICATION_TIME)) AND ((@IsNull_DJACK_SERVICE_VOICE = 1 AND [DJACK_SERVICE_VOICE] IS NULL) OR ([DJACK_SERVICE_VOICE] = @Original_DJACK_SERVICE_VOICE)) AND ((@IsNull_DJACK_INTRODUCE = 1 AND [DJACK_INTRODUCE] IS NULL) OR ([DJACK_INTRODUCE] = @Original_DJACK_INTRODUCE)) AND ((@IsNull_DJACK_CONACTION_TIME = 1 AND [DJACK_CONACTION_TIME] IS NULL) OR ([DJACK_CONACTION_TIME] = @Original_DJACK_CONACTION_TIME)) AND ((@IsNull_DJACK_TRANS_ACCOUNT = 1 AND [DJACK_TRANS_ACCOUNT] IS NULL) OR ([DJACK_TRANS_ACCOUNT] = @Original_DJACK_TRANS_ACCOUNT)) AND ((@IsNull_TRANS_ACCOUNT_TYPE = 1 AND [TRANS_ACCOUNT_TYPE] IS NULL) OR ([TRANS_ACCOUNT_TYPE] = @Original_TRANS_ACCOUNT_TYPE)) AND ((@IsNull_DJACK_SCAN_NUM = 1 AND [DJACK_SCAN_NUM] IS NULL) OR ([DJACK_SCAN_NUM] = @Original_DJACK_SCAN_NUM)) AND ((@IsNull_DJACK_SERVICE_TYPE = 1 AND [DJACK_SERVICE_TYPE] IS NULL) OR ([DJACK_SERVICE_TYPE] = @Original_DJACK_SERVICE_TYPE)) AND ((@IsNull_DJACK_ACCOUNT_BALANCE = 1 AND [DJACK_ACCOUNT_BALANCE] IS NULL) OR ([DJACK_ACCOUNT_BALANCE] = @Original_DJACK_ACCOUNT_BALANCE)) AND ((@IsNull_DJACK_TRANS_COUNT = 1 AND [DJACK_TRANS_COUNT] IS NULL) OR ([DJACK_TRANS_COUNT] = @Original_DJACK_TRANS_COUNT)) AND ((@IsNull_SPECIE_IS_DELETED = 1 AND [SPECIE_IS_DELETED] IS NULL) OR ([SPECIE_IS_DELETED] = @Original_SPECIE_IS_DELETED)) AND ((@IsNull_DJACK_SPECIE_RMK = 1 AND [DJACK_SPECIE_RMK] IS NULL) OR ([DJACK_SPECIE_RMK] = @Original_DJACK_SPECIE_RMK)) AND ((@IsNull_BANK_ID = 1 AND [BANK_ID] IS NULL) OR ([BANK_ID] = @Original_BANK_ID)) AND ((@IsNull_BANK_ACCOUNT = 1 AND [BANK_ACCOUNT] IS NULL) OR ([BANK_ACCOUNT] = @Original_BANK_ACCOUNT)) AND ((@IsNull_BANK_ACCOUNT_NME = 1 AND [BANK_ACCOUNT_NME] IS NULL) OR ([BANK_ACCOUNT_NME] = @Original_BANK_ACCOUNT_NME)) AND ((@IsNull_ADVICE_HTML_URL = 1 AND [ADVICE_HTML_URL] IS NULL) OR ([ADVICE_HTML_URL] = @Original_ADVICE_HTML_URL)) AND ((@IsNull_DJACK_TRADING_NUMBER = 1 AND [DJACK_TRADING_NUMBER] IS NULL) OR ([DJACK_TRADING_NUMBER] = @Original_DJACK_TRADING_NUMBER)));
SELECT DJACK_SPECIEINFO_ID, BECOME_DJACK_TIME, DJACK_IS_CERTIFICATION, CERTIFICATION_TIME, DJACK_SERVICE_VOICE, DJACK_INTRODUCE, DJACK_CONACTION_TIME, DJACK_TRANS_ACCOUNT, TRANS_ACCOUNT_TYPE, DJACK_SCAN_NUM, DJACK_SERVICE_TYPE, DJACK_TRAVEL_ADVICE, DJACK_ACCOUNT_BALANCE, DJACK_TRANS_COUNT, SPECIE_IS_DELETED, DJACK_SPECIE_RMK, BANK_ID, BANK_ACCOUNT, BANK_ACCOUNT_NME, ADVICE_HTML_URL, DJACK_TRADING_NUMBER FROM DJK_DJACK_SPECIEINFO WHERE (DJACK_SPECIEINFO_ID = @DJACK_SPECIEINFO_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_SPECIEINFO_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_SPECIEINFO_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@BECOME_DJACK_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="BECOME_DJACK_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@DJACK_IS_CERTIFICATION" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DJACK_IS_CERTIFICATION" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CERTIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CERTIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_SERVICE_VOICE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_SERVICE_VOICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_INTRODUCE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_INTRODUCE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_CONACTION_TIME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_CONACTION_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_TRANS_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_TRANS_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TRANS_ACCOUNT_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRANS_ACCOUNT_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DJACK_SCAN_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_SCAN_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DJACK_SERVICE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_SERVICE_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_TRAVEL_ADVICE" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="DJACK_TRAVEL_ADVICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DJACK_ACCOUNT_BALANCE" Precision="15" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DJACK_ACCOUNT_BALANCE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DJACK_TRANS_COUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_TRANS_COUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SPECIE_IS_DELETED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SPECIE_IS_DELETED" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DJACK_SPECIE_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_SPECIE_RMK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BANK_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BANK_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BANK_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BANK_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BANK_ACCOUNT_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BANK_ACCOUNT_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ADVICE_HTML_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADVICE_HTML_URL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DJACK_TRADING_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_TRADING_NUMBER" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_SPECIEINFO_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_SPECIEINFO_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BECOME_DJACK_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BECOME_DJACK_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_BECOME_DJACK_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="BECOME_DJACK_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_IS_CERTIFICATION" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_IS_CERTIFICATION" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_DJACK_IS_CERTIFICATION" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DJACK_IS_CERTIFICATION" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CERTIFICATION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CERTIFICATION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CERTIFICATION_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CERTIFICATION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_SERVICE_VOICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_SERVICE_VOICE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_SERVICE_VOICE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_SERVICE_VOICE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_INTRODUCE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_INTRODUCE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_INTRODUCE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_INTRODUCE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_CONACTION_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_CONACTION_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_CONACTION_TIME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_CONACTION_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_TRANS_ACCOUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_TRANS_ACCOUNT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_TRANS_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_TRANS_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRANS_ACCOUNT_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRANS_ACCOUNT_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TRANS_ACCOUNT_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRANS_ACCOUNT_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_SCAN_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_SCAN_NUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DJACK_SCAN_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_SCAN_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_SERVICE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_SERVICE_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DJACK_SERVICE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_SERVICE_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_ACCOUNT_BALANCE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_ACCOUNT_BALANCE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DJACK_ACCOUNT_BALANCE" Precision="15" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DJACK_ACCOUNT_BALANCE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_TRANS_COUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_TRANS_COUNT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DJACK_TRANS_COUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_TRANS_COUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SPECIE_IS_DELETED" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SPECIE_IS_DELETED" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_SPECIE_IS_DELETED" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SPECIE_IS_DELETED" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_SPECIE_RMK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_SPECIE_RMK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DJACK_SPECIE_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DJACK_SPECIE_RMK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BANK_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BANK_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BANK_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BANK_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BANK_ACCOUNT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BANK_ACCOUNT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BANK_ACCOUNT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BANK_ACCOUNT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BANK_ACCOUNT_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BANK_ACCOUNT_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BANK_ACCOUNT_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BANK_ACCOUNT_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ADVICE_HTML_URL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ADVICE_HTML_URL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ADVICE_HTML_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ADVICE_HTML_URL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_TRADING_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_TRADING_NUMBER" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DJACK_TRADING_NUMBER" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_TRADING_NUMBER" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DJACK_SPECIEINFO_ID" DataSetColumn="DJACK_SPECIEINFO_ID" />
              <Mapping SourceColumn="BECOME_DJACK_TIME" DataSetColumn="BECOME_DJACK_TIME" />
              <Mapping SourceColumn="DJACK_IS_CERTIFICATION" DataSetColumn="DJACK_IS_CERTIFICATION" />
              <Mapping SourceColumn="CERTIFICATION_TIME" DataSetColumn="CERTIFICATION_TIME" />
              <Mapping SourceColumn="DJACK_SERVICE_VOICE" DataSetColumn="DJACK_SERVICE_VOICE" />
              <Mapping SourceColumn="DJACK_INTRODUCE" DataSetColumn="DJACK_INTRODUCE" />
              <Mapping SourceColumn="DJACK_CONACTION_TIME" DataSetColumn="DJACK_CONACTION_TIME" />
              <Mapping SourceColumn="DJACK_TRANS_ACCOUNT" DataSetColumn="DJACK_TRANS_ACCOUNT" />
              <Mapping SourceColumn="TRANS_ACCOUNT_TYPE" DataSetColumn="TRANS_ACCOUNT_TYPE" />
              <Mapping SourceColumn="DJACK_SCAN_NUM" DataSetColumn="DJACK_SCAN_NUM" />
              <Mapping SourceColumn="DJACK_SERVICE_TYPE" DataSetColumn="DJACK_SERVICE_TYPE" />
              <Mapping SourceColumn="DJACK_TRAVEL_ADVICE" DataSetColumn="DJACK_TRAVEL_ADVICE" />
              <Mapping SourceColumn="DJACK_ACCOUNT_BALANCE" DataSetColumn="DJACK_ACCOUNT_BALANCE" />
              <Mapping SourceColumn="DJACK_TRANS_COUNT" DataSetColumn="DJACK_TRANS_COUNT" />
              <Mapping SourceColumn="SPECIE_IS_DELETED" DataSetColumn="SPECIE_IS_DELETED" />
              <Mapping SourceColumn="DJACK_SPECIE_RMK" DataSetColumn="DJACK_SPECIE_RMK" />
              <Mapping SourceColumn="BANK_ID" DataSetColumn="BANK_ID" />
              <Mapping SourceColumn="BANK_ACCOUNT" DataSetColumn="BANK_ACCOUNT" />
              <Mapping SourceColumn="BANK_ACCOUNT_NME" DataSetColumn="BANK_ACCOUNT_NME" />
              <Mapping SourceColumn="ADVICE_HTML_URL" DataSetColumn="ADVICE_HTML_URL" />
              <Mapping SourceColumn="DJACK_TRADING_NUMBER" DataSetColumn="DJACK_TRADING_NUMBER" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CDmDjkDjackSpecieInfo" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="CDmDjkDjackSpecieInfo" msprop:Generator_UserDSName="CDmDjkDjackSpecieInfo">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DJK_DJACK_SPECIEINFO" msprop:Generator_TableClassName="DJK_DJACK_SPECIEINFODataTable" msprop:Generator_TableVarName="tableDJK_DJACK_SPECIEINFO" msprop:Generator_TablePropName="DJK_DJACK_SPECIEINFO" msprop:Generator_RowDeletingName="DJK_DJACK_SPECIEINFORowDeleting" msprop:Generator_RowChangingName="DJK_DJACK_SPECIEINFORowChanging" msprop:Generator_RowEvHandlerName="DJK_DJACK_SPECIEINFORowChangeEventHandler" msprop:Generator_RowDeletedName="DJK_DJACK_SPECIEINFORowDeleted" msprop:Generator_UserTableName="DJK_DJACK_SPECIEINFO" msprop:Generator_RowChangedName="DJK_DJACK_SPECIEINFORowChanged" msprop:Generator_RowEvArgName="DJK_DJACK_SPECIEINFORowChangeEvent" msprop:Generator_RowClassName="DJK_DJACK_SPECIEINFORow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DJACK_SPECIEINFO_ID" msprop:Generator_ColumnVarNameInTable="columnDJACK_SPECIEINFO_ID" msprop:Generator_ColumnPropNameInRow="DJACK_SPECIEINFO_ID" msprop:Generator_ColumnPropNameInTable="DJACK_SPECIEINFO_IDColumn" msprop:Generator_UserColumnName="DJACK_SPECIEINFO_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BECOME_DJACK_TIME" msprop:Generator_ColumnVarNameInTable="columnBECOME_DJACK_TIME" msprop:Generator_ColumnPropNameInRow="BECOME_DJACK_TIME" msprop:Generator_ColumnPropNameInTable="BECOME_DJACK_TIMEColumn" msprop:Generator_UserColumnName="BECOME_DJACK_TIME" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DJACK_IS_CERTIFICATION" msprop:Generator_ColumnVarNameInTable="columnDJACK_IS_CERTIFICATION" msprop:Generator_ColumnPropNameInRow="DJACK_IS_CERTIFICATION" msprop:Generator_ColumnPropNameInTable="DJACK_IS_CERTIFICATIONColumn" msprop:Generator_UserColumnName="DJACK_IS_CERTIFICATION" type="xs:boolean" minOccurs="0" />
              <xs:element name="CERTIFICATION_TIME" msprop:Generator_ColumnVarNameInTable="columnCERTIFICATION_TIME" msprop:Generator_ColumnPropNameInRow="CERTIFICATION_TIME" msprop:Generator_ColumnPropNameInTable="CERTIFICATION_TIMEColumn" msprop:Generator_UserColumnName="CERTIFICATION_TIME" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DJACK_SERVICE_VOICE" msprop:Generator_ColumnVarNameInTable="columnDJACK_SERVICE_VOICE" msprop:Generator_ColumnPropNameInRow="DJACK_SERVICE_VOICE" msprop:Generator_ColumnPropNameInTable="DJACK_SERVICE_VOICEColumn" msprop:Generator_UserColumnName="DJACK_SERVICE_VOICE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="800" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DJACK_INTRODUCE" msprop:Generator_ColumnVarNameInTable="columnDJACK_INTRODUCE" msprop:Generator_ColumnPropNameInRow="DJACK_INTRODUCE" msprop:Generator_ColumnPropNameInTable="DJACK_INTRODUCEColumn" msprop:Generator_UserColumnName="DJACK_INTRODUCE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DJACK_CONACTION_TIME" msprop:Generator_ColumnVarNameInTable="columnDJACK_CONACTION_TIME" msprop:Generator_ColumnPropNameInRow="DJACK_CONACTION_TIME" msprop:Generator_ColumnPropNameInTable="DJACK_CONACTION_TIMEColumn" msprop:Generator_UserColumnName="DJACK_CONACTION_TIME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="400" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DJACK_TRANS_ACCOUNT" msprop:Generator_ColumnVarNameInTable="columnDJACK_TRANS_ACCOUNT" msprop:Generator_ColumnPropNameInRow="DJACK_TRANS_ACCOUNT" msprop:Generator_ColumnPropNameInTable="DJACK_TRANS_ACCOUNTColumn" msprop:Generator_UserColumnName="DJACK_TRANS_ACCOUNT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TRANS_ACCOUNT_TYPE" msprop:Generator_ColumnVarNameInTable="columnTRANS_ACCOUNT_TYPE" msprop:Generator_ColumnPropNameInRow="TRANS_ACCOUNT_TYPE" msprop:Generator_ColumnPropNameInTable="TRANS_ACCOUNT_TYPEColumn" msprop:Generator_UserColumnName="TRANS_ACCOUNT_TYPE" type="xs:int" minOccurs="0" />
              <xs:element name="DJACK_SCAN_NUM" msprop:Generator_ColumnVarNameInTable="columnDJACK_SCAN_NUM" msprop:Generator_ColumnPropNameInRow="DJACK_SCAN_NUM" msprop:Generator_ColumnPropNameInTable="DJACK_SCAN_NUMColumn" msprop:Generator_UserColumnName="DJACK_SCAN_NUM" type="xs:int" minOccurs="0" />
              <xs:element name="DJACK_SERVICE_TYPE" msprop:Generator_ColumnVarNameInTable="columnDJACK_SERVICE_TYPE" msprop:Generator_ColumnPropNameInRow="DJACK_SERVICE_TYPE" msprop:Generator_ColumnPropNameInTable="DJACK_SERVICE_TYPEColumn" msprop:Generator_UserColumnName="DJACK_SERVICE_TYPE" type="xs:int" minOccurs="0" />
              <xs:element name="DJACK_TRAVEL_ADVICE" msprop:Generator_ColumnVarNameInTable="columnDJACK_TRAVEL_ADVICE" msprop:Generator_ColumnPropNameInRow="DJACK_TRAVEL_ADVICE" msprop:Generator_ColumnPropNameInTable="DJACK_TRAVEL_ADVICEColumn" msprop:Generator_UserColumnName="DJACK_TRAVEL_ADVICE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DJACK_ACCOUNT_BALANCE" msprop:Generator_ColumnVarNameInTable="columnDJACK_ACCOUNT_BALANCE" msprop:Generator_ColumnPropNameInRow="DJACK_ACCOUNT_BALANCE" msprop:Generator_ColumnPropNameInTable="DJACK_ACCOUNT_BALANCEColumn" msprop:Generator_UserColumnName="DJACK_ACCOUNT_BALANCE" type="xs:decimal" minOccurs="0" />
              <xs:element name="DJACK_TRANS_COUNT" msprop:Generator_ColumnVarNameInTable="columnDJACK_TRANS_COUNT" msprop:Generator_ColumnPropNameInRow="DJACK_TRANS_COUNT" msprop:Generator_ColumnPropNameInTable="DJACK_TRANS_COUNTColumn" msprop:Generator_UserColumnName="DJACK_TRANS_COUNT" type="xs:int" minOccurs="0" />
              <xs:element name="SPECIE_IS_DELETED" msprop:Generator_ColumnVarNameInTable="columnSPECIE_IS_DELETED" msprop:Generator_ColumnPropNameInRow="SPECIE_IS_DELETED" msprop:Generator_ColumnPropNameInTable="SPECIE_IS_DELETEDColumn" msprop:Generator_UserColumnName="SPECIE_IS_DELETED" type="xs:boolean" minOccurs="0" />
              <xs:element name="DJACK_SPECIE_RMK" msprop:Generator_ColumnVarNameInTable="columnDJACK_SPECIE_RMK" msprop:Generator_ColumnPropNameInRow="DJACK_SPECIE_RMK" msprop:Generator_ColumnPropNameInTable="DJACK_SPECIE_RMKColumn" msprop:Generator_UserColumnName="DJACK_SPECIE_RMK" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BANK_ID" msprop:Generator_ColumnVarNameInTable="columnBANK_ID" msprop:Generator_ColumnPropNameInRow="BANK_ID" msprop:Generator_ColumnPropNameInTable="BANK_IDColumn" msprop:Generator_UserColumnName="BANK_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BANK_ACCOUNT" msprop:Generator_ColumnVarNameInTable="columnBANK_ACCOUNT" msprop:Generator_ColumnPropNameInRow="BANK_ACCOUNT" msprop:Generator_ColumnPropNameInTable="BANK_ACCOUNTColumn" msprop:Generator_UserColumnName="BANK_ACCOUNT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BANK_ACCOUNT_NME" msprop:Generator_ColumnVarNameInTable="columnBANK_ACCOUNT_NME" msprop:Generator_ColumnPropNameInRow="BANK_ACCOUNT_NME" msprop:Generator_ColumnPropNameInTable="BANK_ACCOUNT_NMEColumn" msprop:Generator_UserColumnName="BANK_ACCOUNT_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ADVICE_HTML_URL" msprop:Generator_ColumnVarNameInTable="columnADVICE_HTML_URL" msprop:Generator_ColumnPropNameInRow="ADVICE_HTML_URL" msprop:Generator_ColumnPropNameInTable="ADVICE_HTML_URLColumn" msprop:Generator_UserColumnName="ADVICE_HTML_URL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DJACK_TRADING_NUMBER" msprop:Generator_ColumnVarNameInTable="columnDJACK_TRADING_NUMBER" msprop:Generator_ColumnPropNameInRow="DJACK_TRADING_NUMBER" msprop:Generator_ColumnPropNameInTable="DJACK_TRADING_NUMBERColumn" msprop:Generator_UserColumnName="DJACK_TRADING_NUMBER" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DJK_DJACK_SPECIEINFO" />
      <xs:field xpath="mstns:DJACK_SPECIEINFO_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>